﻿CREATE TABLE [dbo].[t_References] (
    [ID]               INT            IDENTITY (1, 1) NOT NULL,
    [BorrowerID]       INT            NOT NULL,
    [Name]             NVARCHAR (128) NULL,
    [Relation]         VARCHAR (50)   NULL,
    [Address]          VARCHAR (128)  NULL,
    [Phone]            VARCHAR (128)  NULL,
    [Phone1]           VARCHAR (128)  NULL,
    [Note]             NVARCHAR (512) NULL,
    [InterviewWeight]  INT            NOT NULL,
    [InterviewWeight1] INT            NOT NULL,
    [InterviewDate]    SMALLDATETIME  NULL,
    [InterviewDate_F]  AS             ([dbo].[Date_Format]([InterviewDate],(2))),
    [InterviewByWho]   NVARCHAR (50)  NULL,
    [Language]         NVARCHAR (2)   NULL
);

